<?php
$con = mysql_connect("localhost","admin","catan");
	// Create database
	if (mysql_query("CREATE DATABASE my_db",$con))
	{
		echo "Database created";
	}
	else
	{
		echo "Error creating database: " . mysql_error();
	}
	
	// Create table
	mysql_select_db("my_db", $con);
	$sql = "CREATE TABLE Players(PersonID int NOT NULL AUTO_INCREMENT,PRIMARY KEY(PersonID),FirstName varchar(15),LastName varchar(15),Color varchar(10),TotalPoint int)";
	mysql_query($sql,$con);
?>